Release 10.1A: OpenEdge Development:
Progress 4GL Reference

EMPTY TEMP-TABLE statement

Empties a temp-table.

Temp-tables defined as NO-UNDO can be emptied within a transaction. Temp-tables that are defined as UNDO or default to UNDO can only be emptied as long as no transaction is active, whether or not it involves records in the temp-table.

Note: This statement corresponds to the EMPTY-TEMP-TABLE( ) method.

Syntax

EMPTY TEMP-TABLE temp-table-name [ NO-ERROR ]

temp-table-name

The name of the temp-table.

NO-ERROR

Specifies that any errors that occur in the attempt to empty the temp-table are suppressed. After the EMPTY TEMP-TABLE statement completes, you can check the ERROR-STATUS system handle for any errors that occurred.

See also

EMPTY-TEMP-TABLE( ) method